<?php

/**
 * Controller is the customized base controller class.
 * All controller classes for this application should extend from this base
 * class.
 */
class Controller extends CController {

	/**
	 * @var string the default layout for the controller view.
	 * Defaults to '//layouts/column1', meaning using a single column layout.
	 * See 'protected/views/layouts/column1.php'.
	 */
	public $layout = '//layouts/column1';

	/**
	 * @var array context menu items.
	 * This property will be assigned to {@link CMenu::items}.
	 */
	public $menu = array();

	/**
	 * @var array the breadcrumbs of the current page.
	 * The value of this property will be assigned to
	 * {@link CBreadcrumbs::links}.
	 * Please refer to {@link CBreadcrumbs::links} for more details on how to
	 * specify this property.
	 */
	public $breadcrumbs = array();

	protected function _autoComplete($table, $attr) {
		if (isset($_GET['term'])) {
			$cmd = Yii::app()->db->createCommand();
			$cmd->from($table);
			$cmd->selectDistinct($attr);
			$cmd->order("$attr");
			$params = array(":term"=>'%' . $_GET['term'] . '%');
			$cmd->where("$attr LIKE :term", $params);
			$cols = $cmd->queryColumn();
			echo CJSON::encode($cols);
			Yii::app()->end();
		}
	}

}